Object Query Optimization through Detecting Independent Subqueries

نویسندگان

  • Jacek Plodzien
  • Anna Kraken
چکیده

Database Switching includes execution of queries on same or different machines connected in LAN with different backend without rewriting any queries. Switching between the databases reduces the work of rewriting the queries for each of the database thus saving time. User just has to select the Source DBMS and Table from that DBMS and a switch file is created on a click of a button. Now this switch file can be used in any machine (can be a remote machine) to switch data in any of the DBMS. Database GUI helps a user to do all database operations through a GUI provided with minimal knowledge of the database. Here user can do all database activities like Creating Table, Inserting Data, Joining two tables etc with minimal knowledge of queries without having the knowledge of whole database can access through GUI.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Query Optimization in Object Oriented Databases through Detecting Independent Subqueries

Query optimization is the refining process in database administration and it helps to bring down speed of execution. Some object-oriented languages allows to express queries explicitly in the code, which are optimized using the query optimization techniques from the database domain. With respect to this, a formalized object query language (OQL) has been developed that performs optimization of q...

متن کامل

Implementation of Optimization in Object-Oriented Queries

Query optimization techniques are dependent upon the query model and language. The query model, in turn, is based on the data (or object) model since it defines the access primitives which are used by the query model. These primitives determine the power of the query model. Object-oriented languages allow expressing queries explicitly in the code, which are optimized using the query optimizatio...

متن کامل

Optimization of Object-Oriented Queries through Rewriting Compound Weakly Dependent Subqueries

A new static optimization method for object-oriented queries is presented. We deal with a special class of subqueries of a given query called “compound weakly dependent subqueries”. The dependency is considered in the context of SBQL non-algebraic query operators like selection, projection, join, etc. A subquery is weakly dependent from its nearest non-algebraic operator if it depends only on e...

متن کامل

Nested Queries in Object Bases

Many declarative query languages for object oriented oo databases allow nested subqueries This paper contains the rst algebra which is capable of handling arbitrary nested queries and the rst complete classi cation of oo nested queries and the according unnesting strategies For unnesting a two phase approach is used The rst phase called dependency based optimization transforms queries at the qu...

متن کامل

Classification And Optimization of Nested Queries in Object Bases

Many declarative query languages for object-oriented (oo) databases allow nested subqueries. This paper contains a complete classiication of oo nested queries and appropriate unnesting optimization strategies based on algebraic rewriting. We adapt some known relational techniques and introduce new ones that use and are concerned with features speciic to object-oriented queries. In particular, w...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:
  • Inf. Syst.

دوره 25  شماره 

صفحات  -

تاریخ انتشار 2000